5-2 Period Close Balances
Writing Period Close Balances
Table of Contents
Writing Period Close Balances 2
Writing Period Close Balances
Processing Summary
- Period Closure Menu
- Generate Period Balances
or
- Work With Storers
- Write Balances
Processing Dialog
Balances can be generated across a range of accounts or for an individual account. Often the balance writing process is established as a scheduled job and simply runs a fixed number of days after the close of each period. To generate balances for a specific account, take the "Write Balances" option from the "Work With Storers" panel. To generate balances for a range of accounts, take the "Generate Period Balances" option from the "Period Closure" menu. If an account does not require a recurring storage invoice, there is really no reason to generate balances for that account.
Before storage charges can be assessed, the inventory balances at the end of the prior period must be determined. Since the balances are typically written one or more days after the close of the period to allow for all shipment paperwork to be processed, the programming must take the current stock balances and roll back the transactions processed after the ending date. It will then record the balance as it was at the close of that day.
Note: WDLS imposes rigor on receiving transactions. They must be confirmed prior to the end of the period to be included in the balance at the end of the period. Receipts that are back posted prior to the period end should not be confirmed until recurring storage invoicing is complete. The storage charges for the prior period will then be included in the storage computation on the warehouse receiving charges.
To generate period balance for the prior period for a range of storers, take the "Generate Period Balance" option from the "Period Closure" menu. The following panel will be displayed:
Key the beginning and ending storer numbers and suffixes for the range you wish to generate. If you want to generate period balances for all storers, enter "*FIRST" in the Starting Storer field, and "*LAST" in the Ending storer field. To generate balance for a single account key the storer number for both the beginning and ending storer.
Note that there is no date specified. The programming will determine the prior period for each account in the range and generate balances for the ending date of that period. If the process is run on the 4th day of the month over 5 accounts in the range and all close on calendar month except one that always closes on the 3rd of the month, 4 accounts will generate balances for the last day of the prior month, and the other will generate balances for the 3rd of the current month.
After you press the <Enter> key the generation process will be submitted to run as a separate job. You will return to the menu. To generate balance for a specific account or to generate balances for a specific date, the "Write Balances" option on the "Work With Storers" panel should be used. The following prompt panel will be displayed.
Key the date of the balance that you wish to write. The balance date should be entered in MMDDYY format. Key a record type of 'P' for period balance. If existing balance records are encountered, they will be over-written. After you press the <Enter> key, the programming will generate the balances for the account. When it is completed, you will return to the "Work With Storers" panel.